package tech.aistar.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tech.aistar.pojo.entity.SingerList;

import java.util.List;
@Mapper
@Repository
public interface SingerListMapper {
    @Select("select * from singer_list")
    List<SingerList> findAll();
    @Select("select * from singer_list where singer_type=#{value}")
    List<SingerList> findFingerType(String value);
    @Select("select * from singer_list where id=#{id}")
    SingerList getById(Integer id);

    @Select("select singer_name from singer_list where id=#{value}")
    String getbyid(Integer id);
    @Select("select * from singer_list where singer_name=#{singerName}")
    SingerList getByname(String singerName);
}
